﻿if exists (select 1
            from  sysobjects
           where  id = object_id('SYSTEM_AREAINFO')
            and   type = 'U')
   drop table SYSTEM_AREAINFO
go

/*==============================================================*/
/* Table: SYSTEM_AREAINFO                                       */
/*==============================================================*/
create table SYSTEM_AREAINFO (
   AREACODE             varchar(36)          not null,
   AREANAME             varchar(255)         null,
   BELONGAREA           varchar(36)          null,
   REMARK               varchar(255)         null,
   ENABLEEDIT           char(1)              null,
   CREATEID             char(36)             null,
   CREATEDATE           DATE                 null,
   UPDATEID             char(36)             null,
   UPDATEDATE           DATE                 null,
   constraint PK_SYSTEM_AREAINFO primary key (AreaCode)
)
go
